SherbyNet - /page/wikibook/entry.mu

Micron Document

<!DOCTYPE html>

<title>INP (database)</title>

</head>

<span id="openzim-page-title" class="mw-page-title-main"><span class="mw-page-title-main">INP (database)</span></span>

</h1>

</header>

/* start https://en.wikipedia.org/ */

.mw-parser-output .ambox{border:1px solid #a2a9b1;border-left:10px solid #36c;background-color:#fbfbfb;box-sizing:border-box}.mw-parser-output .ambox+link+.ambox,.mw-parser-output .ambox+link+style+.ambox,.mw-parser-output .ambox+link+link+.ambox,.mw-parser-output .ambox+.mw-empty-elt+link+.ambox,.mw-parser-output .ambox+.mw-empty-elt+link+style+.ambox,.mw-parser-output .ambox+.mw-empty-elt+link+link+.ambox{margin-top:-1px}html body.mediawiki .mw-parser-output .ambox.mbox-small-left{margin:4px 1em 4px 0;overflow:hidden;width:238px;border-collapse:collapse;font-size:88%;line-height:1.25em}.mw-parser-output .ambox-speedy{border-left:10px solid #b32424;background-color:#fee7e6}.mw-parser-output .ambox-delete{border-left:10px solid #b32424}.mw-parser-output .ambox-content{border-left:10px solid #f28500}.mw-parser-output .ambox-style{border-left:10px solid #fc3}.mw-parser-output .ambox-move{border-left:10px solid #9932cc}.mw-parser-output .ambox-protection{border-left:10px solid #a2a9b1}.mw-parser-output .ambox .mbox-text{border:none;padding:0.25em 0.5em;width:100%}.mw-parser-output .ambox .mbox-image{border:none;padding:2px 0 2px 0.5em;text-align:center}.mw-parser-output .ambox .mbox-imageright{border:none;padding:2px 0.5em 2px 0;text-align:center}.mw-parser-output .ambox .mbox-empty-cell{border:none;padding:0;width:1px}.mw-parser-output .ambox .mbox-image-div{width:52px}@media(min-width:720px){.mw-parser-output .ambox{margin:0 10%}}@media print{body.ns-0 .mw-parser-output .ambox{display:none!important}}

/* end https://en.wikipedia.org/ */

</style>

<p><b>INP</b> (pronounced "imp") is a <a href="Database_management_system" class="mw-redirect" title="Database management system">database management system</a> including forms processing data entry. It consists of over fifty utility programs for database access and support, batch updating, and report generation. It was developed by Bob Tidd at the <a href="University_of_California%2C_Berkeley" title="University of California, Berkeley">University of California, Berkeley</a> in 1976, and predated many of the commercial and opensource databases in use today.<sup id="cite_ref-1" class="reference"><a href="#cite_note-1"><span class="cite-bracket">[</span>1<span class="cite-bracket">]</span></a></sup> It is still in use on a wide variety of systems at the university and associated institutions.

</p>

<div class="mw-heading mw-heading2"><h2 id="Features">Features</h2></div>

<p>An INP database may contain up to 100K records of up to 1024 characters (expandable). Up to ten <a href="Database_index" title="Database index">database indexes</a> are allowed. They are <a href="Btrees" class="mw-redirect" title="Btrees">btrees</a> of no more than three levels. Databases must contain fixed length records, but some utilities handle variable length, delimited field records. A newline (RETURN) character at the end of each record makes INP databases accessible to the entire array of <a href="Unix" title="Unix">Unix</a> utilities, including editors, sort, <a href="Grep" title="Grep">grep</a>, awk, etc.

</p><p>In the data entry and update program, each data field is displayed separately on the screen with a descriptive label. Fields may be skipped during entry or duplicated from the previous record.

</p><p>INP validates each data field as it is entered. Validation types vary from simple alphabetic/numeric through ranges of numbers to tables of all allowable values. If a field is incorrect INP displays the validation criteria, beeps, and returns you to the start of the offending field. A mechanism exists to override validation checks. An optional <a href="Audit_trail" title="Audit trail">audit trail</a> of changes is maintained for reference and recovery.

</p><p>The database access program is already compiled. It reads database description files at run time. The record layout and validation criteria are specified in one <a href="Database_schema" title="Database schema">schema</a> file. The specifications for the screen displays are entered into format files. Both are created by the user with any <a href="Text_editor" title="Text editor">text editor</a>. A variety of formats may be created to view or update different parts of a database record.

</p><p>INP is implemented on the <a href="DEC_VAX" class="mw-redirect" title="DEC VAX">DEC VAX</a> and <a href="PDP-11" title="PDP-11">PDP-11</a> under <a href="BSD" class="mw-redirect" title="BSD">BSD Unix</a> or <a href="ULTRIX" class="mw-redirect" title="ULTRIX">ULTRIX</a>. Versions are available for <a href="SunOS" title="SunOS">SunOS</a> and <a href="Onyx" title="Onyx">Onyx</a>. Several operators can simultaneously access or update information in the same database file.

</p><p>Typists and others with little data processing experience find INP easy to use, and they usually become comfortable with the computer related processes rapidly. Like most editors, INP has many command options, but the basic few are easily learned. INP is very forgiving, helpful and bulletproof about data entry and command errors.

</p>

<div class="mw-heading mw-heading2"><h2 id="Applicability">Applicability</h2></div>

<p>INP can be used for any small to medium database or data entry task. Basic applications of INP can be designed and implemented by persons familiar with Unix and the text editor, but without programming experience.

</p><p>INP has two powerful sets of options. The elf package allows user supplied coded functions (in the <a href="C_(programming_language)" title="C (programming language)">C programming language</a>) for special validation and arbitrarily complex operations including forked programs to occur when various INP commands are requested by the operator. This opens up "sky's the limit" possibilities for projects implemented using INP.

</p><p>INP comes with an extensive library of functions, including the keyed database access package, which can be incorporated into custom applications.

</p>

<div class="mw-heading mw-heading2"><h2 id="References">References</h2></div>

/* start https://en.wikipedia.org/ */

.mw-parser-output .reflist{margin-bottom:0.5em;list-style-type:decimal}@media screen{.mw-parser-output .reflist{font-size:90%}}.mw-parser-output .reflist .references{font-size:100%;margin-bottom:0;list-style-type:inherit}.mw-parser-output .reflist-columns-2{column-width:30em}.mw-parser-output .reflist-columns-3{column-width:25em}.mw-parser-output .reflist-columns{margin-top:0.3em}.mw-parser-output .reflist-columns ol{margin-top:0}.mw-parser-output .reflist-columns li{page-break-inside:avoid;break-inside:avoid-column}.mw-parser-output .reflist-upper-alpha{list-style-type:upper-alpha}.mw-parser-output .reflist-upper-roman{list-style-type:upper-roman}.mw-parser-output .reflist-lower-alpha{list-style-type:lower-alpha}.mw-parser-output .reflist-lower-greek{list-style-type:lower-greek}.mw-parser-output .reflist-lower-roman{list-style-type:lower-roman}

/* end https://en.wikipedia.org/ */

</style><div class="reflist">

/* start https://en.wikipedia.org/ */

.mw-parser-output cite.citation{font-style:inherit;word-wrap:break-word}.mw-parser-output .citation q{quotes:"\"""\"""'""'"}.mw-parser-output .citation:target{background-color:rgba(0,127,255,0.133)}.mw-parser-output .id-lock-free.id-lock-free a{background:url("./mw/Lock-green.svg")right 0.1em center/9px no-repeat}.mw-parser-output .id-lock-limited.id-lock-limited a,.mw-parser-output .id-lock-registration.id-lock-registration a{background:url("./mw/Lock-gray-alt-2.svg")right 0.1em center/9px no-repeat}.mw-parser-output .id-lock-subscription.id-lock-subscription a{background:url("./mw/Lock-red-alt-2.svg")right 0.1em center/9px no-repeat}.mw-parser-output .cs1-ws-icon a{background:url("./mw/Wikisource-logo.svg")right 0.1em center/12px no-repeat}body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-free a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-limited a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-registration a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-subscription a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .cs1-ws-icon a{background-size:contain;padding:0 1em 0 0}.mw-parser-output .cs1-code{color:inherit;background:inherit;border:none;padding:inherit}.mw-parser-output .cs1-hidden-error{display:none;color:var(--color-error,#d33)}.mw-parser-output .cs1-visible-error{color:var(--color-error,#d33)}.mw-parser-output .cs1-maint{display:none;color:#085;margin-left:0.3em}.mw-parser-output .cs1-kern-left{padding-left:0.2em}.mw-parser-output .cs1-kern-right{padding-right:0.2em}.mw-parser-output .citation .mw-selflink{font-weight:inherit}@media screen{.mw-parser-output .cs1-format{font-size:95%}html.skin-theme-clientpref-night .mw-parser-output .cs1-maint{color:#18911f}}@media screen and (prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .cs1-maint{color:#18911f}}

/* end https://en.wikipedia.org/ */

</style><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://web.archive.org/web/20050302215133/http://violet.berkeley.edu/~inp/inpdocs/features.inp">"Features of the INP data management system"</a>. Archived from <a rel="nofollow" class="external text" href="http://violet.berkeley.edu/~inp/inpdocs/features.inp">the original</a> on 2005-03-02<span class="reference-accessdate">. Retrieved <span class="nowrap">2008-05-13</span></span>.</cite></span>

</li>

</ol></div></div>

<div class="mw-heading mw-heading2"><h2 id="External_links">External links</h2></div>

<ul><li><a rel="nofollow" class="external text" href="https://web.archive.org/web/20050830195958/http://violet.berkeley.edu/~inp/inpdocs/inpdocs.html">Introduction to the INP database system</a></li>

<li><a rel="nofollow" class="external text" href="https://web.archive.org/web/20070220004605/http://violet.berkeley.edu/~inp/">UC Berkeley homepage for Robert Tidd</a></li></ul></div><div><div class="zim-footer">

This article is issued from <a class="external text" title="Last edited on 2025-07-03" href="https://en.wikipedia.org/wiki/?title=INP_(database)&oldid=1298648440">Wikipedia</a>. The text is available under <a class="external text" href="https://creativecommons.org/licenses/by-sa/4.0/deed.en">Creative Commons Attribution-Share Alike 4.0</a> unless otherwise noted. Additional terms may apply for the media files.

</div>

</div></div>

</div>

</main>

</div>

</body></html>